Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WorkerID (FK)(PK) | A unique system-assigned identifier for the Person who is a particular Worker. | ID_WRKR | Identity | integer | Worker(PA_WRKR) |
WorkerCertificationTypeID (FK)(PK) | A unique system-assigned identifier for a particular kind of WorkerCertification. | CD_TYP_CF_WRKR | Identity | integer | WorkerCertificationType(CO_TYP_CF_WRKR) |
WorkerCertificationIssuingBodyID (FK) | A unique retailer assigned identifier for the government or professional body that issues WorkerCertificates. | ID_BDY_WRKR_CD_ISSG | Identity | integer | WorkerCertificationIssuingBody(PA_BDY_WRKR_CF_ISSG) |
CertificateID | The sequence number printed on the document that differentiates this particular WorkerCertificate from others issued by the same WorkerCertificationIssuingBody. | ID_CF | Name | varchar(40) | |
CertificationDate | The date this WorkerCertificate was issued. | DC_CF | DateCalendar | date | |
EffectiveDate | The date from which this WorkerCertificate is valid. | DC_EF | EffectiveDate | date | |
ExpirationDate | The date from which this WorkerCertificate ceases to be valid. | DC_EP | ExpirationDate | date | |